package com.cat.model.dao.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.cat.model.common.model.common.InterviewVO;

public interface InterviewMapper {

	@Select("select * from interview where id=#{id}")
	public InterviewVO getInterview(@Param("id") long id);
	
	@Select("select * from interview where type=#{type} order by ordering DESC limit #{page},#{size}")
	public List<InterviewVO> getInterviewList(@Param("type") Integer type,@Param("page") Integer page,@Param("size") Integer size);
	
}
